Skip to main content

Waiting for schema metadata lock

Short Description

The server is waiting to acquire a lock from the metadata locking subsystem.

Detailed Description​

The server is waiting to acquire a lock from the metadata locking subsystem, where *lock_type* indicates the type of lock.

These states indicate a wait for a metadata lock:

  • Waiting for event metadata lock
  • Waiting for global read lock
  • Waiting for schema metadata lock
  • Waiting for stored function metadata lock
  • Waiting for stored procedure metadata lock
  • Waiting for table metadata lock
  • Waiting for trigger metadata lock

How to reduce this wait​

  • For information about table lock indicators, see Section 8.11.1, “Internal Locking Methods”.
  • For information about metadata locking, see Section 8.11.4, “Metadata Locking”.
  • To see which locks are blocking lock requests, use the Performance Schema lock tables described at Section 27.12.13, “Performance Schema Lock Tables”.

Search online​

If this article doesn't have the information you need you can try searching online. Remember, you can contribute suggestions to this page.